/*
Navicat SQL Server Data Transfer

Source Server         : 10.5.0.11(relo)
Source Server Version : 110000
Source Host           : 10.5.0.11:1433
Source Database       : relo24_tanky
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2012-10-10 10:49:24
*/


-- ----------------------------
-- Table structure for [dbo].[z_png_webform_location_site]
-- ----------------------------
DROP TABLE [dbo].[z_png_webform_location_site]
GO
CREATE TABLE [dbo].[z_png_webform_location_site] (
[country_code] nvarchar(20) NOT NULL ,
[country_name] nvarchar(120) NOT NULL ,
[site_code] nvarchar(20) NOT NULL ,
[site_name] nvarchar(120) NOT NULL 
)


GO

-- ----------------------------
-- Records of z_png_webform_location_site
-- ----------------------------
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'TR', N'Turkey', N'2734', N'Istanbul General Office HQ');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'JA', N'Japan', N'2875', N'Akashi Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'JA', N'Japan', N'2881', N'Takasaki Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'3158', N'Apizaco Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'3781', N'Irapuato MS Plant - Manufactura');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'4343', N'Schwalbach GO');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'434A', N'Prestige GO');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'434B', N'Schwalbach Innovation Center');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'4353', N'Mariscala Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'4354', N'Naucalpan Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'4356', N'Talisman Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'4357', N'Vallejo Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'JA', N'Japan', N'4379', N'Kobe GO & Innovation Center');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'4397', N'Mexico City GO');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'4498', N'Crailsheim Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'4499', N'Euskirchen Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'4501', N'Gross-Gerau Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'4504', N'Worms Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'TR', N'Turkey', N'4610', N'Gabze Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'TR', N'Turkey', N'4611', N'Istanbul Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'4663', N'Culiacan Cbd Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'4839', N'Tepeji Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'JA', N'Japan', N'4974', N'Nagoya Sales Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'JA', N'Japan', N'4975', N'Miyagi Sales Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'JA', N'Japan', N'4976', N'Osaka Sales Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'4984', N'Guadalajara Region Cbd Offices');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'4985', N'Monterrey Region Cbd Offices');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'JA', N'Japan', N'5006', N'Fukuoka Sales Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'JA', N'Japan', N'5133', N'Tokyo Training Center');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'TR', N'Turkey', N'6142', N'Sekerpinar DC');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'TR', N'Turkey', N'6239', N'Istanbul GO');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'7038', N'Rothenkirchen Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'7042', N'Cologne Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'7043', N'Huenfeld Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'7298', N'Weiterstadt DC');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'7389', N'Mexico City Go - Wella');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'JA', N'Japan', N'7416', N'Fukuoka Studio');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'JA', N'Japan', N'7417', N'Hiroshima Studio');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'JA', N'Japan', N'7418', N'Nagoya Studio');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'JA', N'Japan', N'7420', N'Osaka Studio');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'JA', N'Japan', N'7421', N'Sapporo Studio');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'JA', N'Japan', N'7425', N'Tokyo Tatemono Studio');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'7454', N'Darmstadt GO');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'7458', N'Leipzig Studio');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'7459', N'Leipzig OFC');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'745A', N'Darmstadt Innovation Center');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'7851', N'Altfeld Warehouse');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'7853', N'Berlin Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'7855', N'Kronberg Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'7860', N'Marktheidenfeld Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'DE', N'Germany', N'7863', N'Wallduern Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'7910', N'Mexico City-Fracc-Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'7911', N'Naucalli Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'MX', N'Mexico', N'9294', N'San Martin Obispo Dc');
GO

-- ----------------------------
-- Indexes structure for table z_png_webform_location_site
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table [dbo].[z_png_webform_location_site]
-- ----------------------------
ALTER TABLE [dbo].[z_png_webform_location_site] ADD PRIMARY KEY ([site_code])
GO
